Select query that ignores certain values [closed]

Navigation
-1

I have a query where you selected all the A, B and C values from the "letters" table
But I would like that when it comes to showing my results I would omit, for example, the B 

SELECT * FROM letras where !B

How could I in a select discriminate results when displaying on my table?

the example of the table is 

id, Latra
1,  A
2,  B
3,  C
    
asked by claus 24.07.2018 в 16:27
source

1 answer

1

From what I understand, you want the data to be shown in your "letter" column to not show data that contains "b" in its content.

Then I would do it with a "not like": 

  select * from letras where letra not like '%b%'
    
answered by 24.07.2018 / 16:42
source
Problems showing items in laravel 5.0 Search for data in a JSON