/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

0 vote176 views1 answer
Sql count matching group by
SQL
7 votes182 views3 answers
Can't connect to local mysql server through socket '/tmp/mysql.sock' (2)
SQL
1 vote227 views1 answer
Aqua Data studio postgresql ssl
SQL
1 vote175 views1 answer
Mysql Case sum
SQL
0 vote213 views1 answer
Pl sql join 3 tables
SQL
0 vote164 views1 answer
Back up stored procedures mysql
SQL
1 vote168 views1 answer
How refresh navicat tables to see new tables
SQL
10 votes165 views5 answers
Between keyword in sql
SQL
2 votes290 views5 answers
Unique in sql server
SQL
1 vote152 views1 answer
Import in mysql without a software
SQL

Share