How do I use the % sign?

[chantown]

With "IN"

 

SELECT * FROM users WHERE username IN ('%gal','%saa');

 

^^ that doesn't work.

 

But this works:

 

SELECT * FROM users WHERE username LIKE '%gal' OR username LIKE '%saa';

 

Is there any way I can make it work the first way? Because it saves space + convenicency  a lot.

 

thanks!

[toplay]

Is there any way I can make it work the first way?

No. "IN" is "IN" and "LIKE" is "LIKE".

 

But if you're worried about forming the "where" clause, just have the different values in an array and then use join/implode (with "OR") to help form the query.