PHP Coding Solutions

php coding solution, form validation

Thursday, April 25, 2019

select a row using a value in comma separated fields

mysql query to select a row using a value in comma separated fields

example:  user table

Query: select name where product Id is 5

SELECT * FROM `user` WHERE find_in_set(5,my_product)

Result: 


Posted by Magento at 8:04 AM
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Blog Archive

  • ►  2020 (1)
    • ►  June (1)
  • ▼  2019 (7)
    • ►  July (2)
    • ►  June (2)
    • ►  May (1)
    • ▼  April (2)
      • make image form video url
      • select a row using a value in comma separated fields
  • ►  2018 (5)
    • ►  October (4)
    • ►  September (1)
  • ►  2017 (7)
    • ►  October (1)
    • ►  June (1)
    • ►  May (3)
    • ►  April (1)
    • ►  March (1)
  • ►  2016 (7)
    • ►  December (1)
    • ►  November (1)
    • ►  August (2)
    • ►  June (1)
    • ►  March (2)
  • ►  2015 (9)
    • ►  December (1)
    • ►  November (1)
    • ►  September (3)
    • ►  July (1)
    • ►  June (1)
    • ►  May (1)
    • ►  February (1)
  • ►  2014 (11)
    • ►  September (1)
    • ►  August (1)
    • ►  April (2)
    • ►  March (4)
    • ►  January (3)
  • ►  2013 (13)
    • ►  December (3)
    • ►  November (1)
    • ►  September (4)
    • ►  August (4)
    • ►  July (1)

About Me

Magento
View my complete profile
Simple theme. Powered by Blogger.