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

1 vote130 views1 answer
Oracle select row max date
SQL
2 votes155 views2 answers
How to DROP a table in mysql
SQL
16 votes114 views3 answers
Jwt secret key generator laravel
SQL
0 vote137 views1 answer
Ran rails db:migrate and got == 20210620104415 DeviseCreateUsers: migrating ================================ -- create_table(:users) rails aborted! StandardError: An error has occurred, this and all later migrations canceled: SQLite3::SQLE
SQL
0 vote104 views1 answer
Mssql current date
SQL
0 vote107 views1 answer
T sql less than date
SQL
5 votes115 views1 answer
Oracle asynchronous update
SQL
0 vote104 views1 answer
Group_concat only returns one row
SQL
0 vote115 views1 answer
Rails sql query converstion
SQL
0 vote107 views1 answer
Replace \n sql
SQL