Sql where keyword

Filters results to only include data which meets the given condition.
Example: Returns orders with a quantity of more than 1 item.
SELECT * FROM orders
WHERE quantity > 1;

Sql searching via key word

SELECT id, category, location
FROM table
WHERE
(
    category LIKE '%keyword%'
    OR location LIKE '%keyword%'
)

Source: stackoverflow.com

Similar codes

9 votes125 views3 answers
Where in sql
SQL
48 votes220 views3 answers
Psql create database
SQL
1 vote98 views1 answer
Import in mysql without a software
SQL
0 vote124 views1 answer
Sql date between one week
SQL
0 vote123 views1 answer
Mysql update sequence with order by
SQL
6 votes164 views2 answers
Oracle compile trigger
SQL
1 vote142 views1 answer
Find difference in dates sql
SQL
0 vote140 views1 answer
T sql check active deadlock
SQL
1 vote142 views1 answer
Sql server today minus n
SQL
8 votes147 views1 answer
See all users mysql
SQL