Selecting image names from table
Posted by:
Akash Raj
Date: February 08, 2019 09:53AM
Hi,
I am trying to select all rows in a table that contain a portion of a string in their name for example I wish to select all rows with this portion in the full string '%500x130 michellin.jpg%', the data for that column is stored like so 'C:\parentfolder\childfolder\images\500x130_michellin.jpg'
my query is select count(*) from table_name where myColumnName like '%500x130 michellin.jpg%' but for some reason this is not working.
Subject
Written By
Posted
Selecting image names from table
February 08, 2019 09:53AM
February 08, 2019 01:34PM
February 12, 2019 05:58AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.