Sampling from a database?

Question

MySQL

Good afternoon!
I ran into such a problem, there is a database and in it a table with links to pages and not only links, there are also image formats and css files.
How can I pull out only links so that everything is not pulled into a heap?

Answer 1

If I understand you correctly, something like:

SELECT page_title 
FROM table 
WHERE 
    ( page_title LIKE '*.php' ) 
    OR ( page_title LIKE '*.html' ) 
    OR ( page_title LIKE '*/' ) 
    OR ( page_title LIKE '*.phtml' ) 
    OR ( page_title LIKE '*.html' )