CODEWITHSUNDEEP
mysqlmysql-regexp
congld2509
congld2509

Reputation: 47

How to ignore src, href in search query MySQL?

I have a record in product table and have string field content like this 

<div class="product">
    <a href="https://hostabc/item/3765/" target="_blank">
        <img alt="something" src="/hostabc/photo.jpg" width="100%"/>
    </a>
    <span>
        This is description of product and this doesn't contain 'hostabc' keyword !
    </span>
</div>

I use my keyword hostabc to search like SELECT * FROM product WHERE content LIKE '%hostabc%' and it returns this record.
So how to I ignore keyword hostabc in src or href on my search query (This record will be not found in search result.)
Can anyone help me !!!

Upvotes: 0

Views: 63

Answers (0)

Related Questions