/SQL/Mysql keyword search

Mysql keyword search

Sql searching via key word

SELECT id, description
FROM table
WHERE MATCH (description) AGAINST('keyword1 keyword2')

0

Source: stackoverflow.com

Sql searching via key word

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

0

Source: stackoverflow.com

Mysql keyword search

SELECT title, description
FROM film
WHERE
(
    title LIKE '%Drama%'
    OR description LIKE '%Drama%'
);

0

Source: stackoverflow.com

Similar codes

1 vote117 views1 answer
T-sql find object by name
SQL
3 votes121 views2 answers
Sql end of month
SQL
2 votes122 views1 answer
Oracle drop table free up space
SQL
1 vote117 views5 answers
Sql 2nd highest salary
SQL
1 vote124 views1 answer
Postgresql how to show table names
SQL
0 vote113 views1 answer
Sql python hwo to pass a list in paramerter
SQL
0 vote122 views1 answer
SQLSTATE[42S02]: Base table or view not found: 1146 Tabl
SQL
0 vote110 views1 answer
Renommer schema sql
SQL
0 vote119 views1 answer
How to login to mysql in homestead
SQL
3 votes116 views3 answers
Mysql order by list
SQL

Share