SELECT where row value contains string MySQL

Question

How can I select a row in my MySQL DB where the value of a column contains 'XcodeDev' for example?

I tried:

SELECT * FROM Accounts WHERE Username LIKE '$query'

But it only selects a row were the Username value is exactly the same to the query.

What can I do to achieve what I want?

Matt Ball · Accepted Answer · 2011-06-22 23:52:03Z

102

Use the % wildcard, which matches any number of characters.

SELECT * FROM Accounts WHERE Username LIKE '%query%'

answered Jun 22, 2011 at 23:52

Matt Ball

361k102 gold badges655 silver badges725 bronze badges

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

2 Comments

Adam Over a year ago

I think you are missing the doller sign

Rahul Bali Over a year ago

very useful +1.

jncraton · Accepted Answer · 2011-06-22 23:52:08Z

18

This should work:

SELECT * FROM Accounts WHERE Username LIKE '%$query%'

answered Jun 22, 2011 at 23:52

jncraton

9,1924 gold badges36 silver badges52 bronze badges

1 Comment

jncraton Over a year ago

This is used to denote variable names in PHP.

Srivatsan · Accepted Answer · 2014-12-04 17:43:48Z

7

My suggestion would be

$value = $_POST["myfield"];

$Query = Database::Prepare("SELECT * FROM TABLE WHERE MYFIELD LIKE ?");
$Query->Execute(array("%".$value."%"));

edited Dec 4, 2014 at 17:43

Srivatsan

9,38313 gold badges62 silver badges92 bronze badges

answered Dec 4, 2014 at 16:44

Marcelo

711 silver badge1 bronze badge

2 Comments

Simon Over a year ago

Hello @Marcelo what can use instead of Database class in the prepare statement? There was a compile error for the Database class.

Simon Over a year ago

@ThePredator ^^

dynamic · Accepted Answer · 2011-06-22 23:52:24Z

3

SELECT * FROM Accounts WHERE Username LIKE '%$query%'

but it's not suggested. use PDO

answered Jun 22, 2011 at 23:52

dynamic

48.2k56 gold badges163 silver badges236 bronze badges

Collectives™ on Stack Overflow

SELECT where row value contains string MySQL

4 Answers 4

2 Comments

1 Comment

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

1 Comment

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related