like-4%_.sql

来自「本程序中即有讲义」· SQL 代码 · 共 13 行

SELECT t.title_id, t.title ,a.au_lname

FROM authors a, titleauthor ta, titles t

WHERE a.au_id = ta.au_id AND ta.title_id = t.title_id

    AND a.au_lname like 'd_l_'
--like 'd_l%'
--LIKE 'd%'
--LIKE '[rsd]%'