- Code: Select all
SELECT id,title_ger,title_orig,release,storage FROM movies WHERE title_ger LIKE '%test%' OR title_orig LIKE '%test%' ORDER BY title_ger
Jemand ne Idee, woran's liegen koennte?
SELECT id,title_ger,title_orig,release,storage FROM movies WHERE title_ger LIKE '%test%' OR title_orig LIKE '%test%' ORDER BY title_ger
SELECT
`id`, `title_ger`, `title_orig`, `release`, `storage`
FROM
`movies`
WHERE
`title_ger` LIKE '%test%' OR
`title_orig` LIKE '%test%'
ORDER BY
`title_ger`
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'release,storage FROM movies WHERE title_ger LIKE '%test%' OR title_orig LIKE '%t' at line 1
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''movies' WHERE 'title_ger' LIKE '%test%' OR 'title_orig' LIKE '%test%' ORDER B' at line 1
Users browsing this forum: No registered users and 6 guests