optimise query

This project received 24 bids from talented freelancers with an average bid price of $25 USD.

Get free quotes for a project like this
Project Budget
$10 - $30 USD
Total Bids
Project Description

Hi i want optimise or index this query for faster because is very slow :

SELECT * FROM rooms WHERE caption LIKE '%micamillle%' OR owner LIKE '%micamillle%' AND roomtype = 'private' ORDER BY users_now DESC LIMIT 50

Skills Required

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online