Check if a value is contained in the line

Question

Check if a value is contained in the line

Navigation

#1 by (5 votes)

4

I'm working with a query system, and I would like, for example: If I look for the "a" value, it would return all the rows that have "a". I tried using the like command, as shown below:

SELECT * FROM usuario WHERE nome LIKE 'a%';

But it only returns me if the value is at the beginning of the line. How can I check if "a" is contained in the line?

mysql

asked by anonymous 04.09.2017 / 15:01

1 answer

What is the use of default interface methods? Create array with string in php?

score 5 · Accepted Answer

The% is a wildcard that represents "anything". That is, the search is being done by names that start with "a" and have anything later .

You only need to adapt anything before and after from "a".

SELECT * FROM usuario WHERE nome LIKE '%a%';