2020-04-08, 10:03
(2020-04-08, 01:18)geek-baba Wrote: Thank you! Figured certification field works better, because MPPA field has "Rated R" so above query will fetch almost 99% of the movies.The % char in the query is the same like * in Windows. That's the reason why "every rating starting with "r" will be listed.
If you one want to search for "Rated R" than you can use
orsql:SELECT * FROM movielist WHERE MPAA LIKE 'Rated R'
sql:SELECT * FROM movielist WHERE Certification LIKE 'USA:R'