MySQL: How to search from two fields?

Question

I have a table called optima with a few fields and I need to make a query that will return me results where field1 = a and field2 = b.

Table for example

F1 F2
_____
a  z
v  a
a  b
b  a

result must be:

a  b

I was trying to make query like

SELECT * FROM `optima` WHERE `F1` LIKE 'a' AND `F2` LIKE 'b';

but it returns me nothing.

Backticks or back quotes are occasionally necessary, but you should avoid them where they are not. The table name does not need backticks; the only reason the column names might need backticks are because they are in upper-case and were enclosed in backticks when the table was created. — Jonathan Leffler
– Jonathan Leffler, Commented Apr 23, 2012 at 14:02

D'Arcy Rittich · Accepted Answer · 2012-04-23 13:44:06Z

2

For an exact match, use the = operator, e.g.:

select *
from `optima`
where `F1` = 'a' and `F2` = 'b';

answered Apr 23, 2012 at 13:44

D'Arcy Rittich

172k41 gold badges298 silver badges287 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Bohemian Over a year ago

Do you have backtickitis or something?

Marcus Adams Over a year ago

I think in this case LIKE is more exact, since it performs comparison character by character and considers trailing spaces. Though, = might be better since trailing spaces will be ignored, which might be the issue.

Sergii Rechmp Over a year ago

and what if i need to search something like that: a, b% in table with a, bc? so just use like, not =?

D'Arcy Rittich Over a year ago

@SergiiRechmp select * from optima where F1 = 'a' and F2 like 'b%';

Collectives™ on Stack Overflow

MySQL: How to search from two fields?

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related